﻿-- Creating table 'LogPhysicianSchedules'
-- Creating table 'LogPhysicianSchedules'
-- Creating table 'LogPhysicianSchedules'
-- Creating table 'LogPhysicianSchedules'
-- Creating table 'LogPhysicianSchedules'
CREATE TABLE [dbo].[LogPhysicianSchedules] (
    [LogPhysicianScheduleID] int IDENTITY(1,1) NOT NULL,
    [EmployeeCode] nvarchar(5)  NOT NULL,
    [LogDateTime] datetime  NOT NULL,
    [Action] int  NOT NULL,
    [PhysicianScheduleID] int  NOT NULL
);














